home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
fareclasses.ctl
< prev
next >
Wrap
Text File
|
2000-05-12
|
775b
|
32 lines
-- RCSVER $Id: fareclasses.ctl,v 1.1 2000-05-03 12:29:01-05 randy Exp $ */
-- *************************************************************************
-- Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
--
-- Name: fareclasses.ctl
-- Date: 02/23/1999
-- memo: Randy Wood
-- Description: Load the data for the status table.
-- Changes:
-- *********************************************************************** */
LOAD DATA
INFILE *
INTO TABLE fareclasses
fields terminated by "|"
trailing nullcols
(
class_num,
descr,
code,
config_num,
is_magnetic
)
begindata
1|Normal|N|1|0|
2|Discount|D|1|0|
3|Transfer|R|1|0|
4|Special|S|1|0|
5|Pass|P|1|0|
6|Inactive|X|1|0|
7|Magnetic pass/xfer|M|1|1|
8|Stored value card|C|1|1|